Profiling Report

Overview
Reproduction

Dataset statistics

Number of variables	10
Number of observations	20433
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	88.0 B

Variable types

Numeric	9
Categorical	1

Reproduction

Analysis started	2024-05-30 21:45:12.486928
Analysis finished	2024-05-30 21:45:18.220256
Duration	5.73 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

longitude
Real number (ℝ)

Distinct	844
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-119.57069

Minimum	-124.35
Maximum	-114.31
Zeros	0
Zeros (%)	0.0%
Negative	20433
Negative (%)	100.0%
Memory size	319.3 KiB

Quantile statistics

Minimum	-124.35
5-th percentile	-122.47
Q1	-121.8
median	-118.49
Q3	-118.01
95-th percentile	-117.08
Maximum	-114.31
Range	10.04
Interquartile range (IQR)	3.79

Descriptive statistics

Standard deviation	2.0035779
Coefficient of variation (CV)	-0.01675643
Kurtosis	-1.3325482
Mean	-119.57069
Median Absolute Deviation (MAD)	1.29
Skewness	-0.2961409
Sum	-2443187.9
Variance	4.0143244
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-118.31	159	0.8%
-118.3	157	0.8%
-118.29	146	0.7%
-118.27	141	0.7%
-118.32	141	0.7%
-118.28	139	0.7%
-118.35	138	0.7%
-118.36	135	0.7%
-118.19	134	0.7%
-118.37	126	0.6%
Other values (834)	19017	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-124.35	1	< 0.1%
-124.3	2	< 0.1%
-124.27	1	< 0.1%
-124.26	1	< 0.1%
-124.25	1	< 0.1%
-124.23	3	< 0.1%
-124.22	1	< 0.1%
-124.21	3	< 0.1%
-124.19	4	< 0.1%
-124.18	6	< 0.1%

Value	Count	Frequency (%)
-114.31	1	< 0.1%
-114.47	1	< 0.1%
-114.49	1	< 0.1%
-114.55	1	< 0.1%
-114.56	1	< 0.1%
-114.57	3	< 0.1%
-114.58	2	< 0.1%
-114.59	1	< 0.1%
-114.6	3	< 0.1%
-114.61	3	< 0.1%

latitude
Real number (ℝ)

Distinct	861
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.633221

Minimum	32.54
Maximum	41.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	319.3 KiB

Quantile statistics

Minimum	32.54
5-th percentile	32.82
Q1	33.93
median	34.26
Q3	37.72
95-th percentile	38.96
Maximum	41.95
Range	9.41
Interquartile range (IQR)	3.79

Descriptive statistics

Standard deviation	2.1363477
Coefficient of variation (CV)	0.059953818
Kurtosis	-1.1195226
Mean	35.633221
Median Absolute Deviation (MAD)	1.23
Skewness	0.46493428
Sum	728093.61
Variance	4.5639814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34.06	241	1.2%
34.08	232	1.1%
34.05	229	1.1%
34.07	227	1.1%
34.04	215	1.1%
34.09	209	1.0%
34.02	207	1.0%
34.1	201	1.0%
34.03	189	0.9%
33.93	181	0.9%
Other values (851)	18302	89.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
32.54	1	< 0.1%
32.55	3	< 0.1%
32.56	10	< 0.1%
32.57	18	0.1%
32.58	26	0.1%
32.59	11	0.1%
32.6	9	< 0.1%
32.61	14	0.1%
32.62	13	0.1%
32.63	18	0.1%

Value	Count	Frequency (%)
41.95	2	< 0.1%
41.92	1	< 0.1%
41.88	1	< 0.1%
41.86	3	< 0.1%
41.84	1	< 0.1%
41.82	1	< 0.1%
41.81	2	< 0.1%
41.8	3	< 0.1%
41.79	1	< 0.1%
41.78	3	< 0.1%

housing_median_age
Real number (ℝ)

Distinct	52
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.633094

Minimum	1
Maximum	52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	319.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	18
median	29
Q3	37
95-th percentile	52
Maximum	52
Range	51
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	12.591805
Coefficient of variation (CV)	0.43976405
Kurtosis	-0.80101334
Mean	28.633094
Median Absolute Deviation (MAD)	10
Skewness	0.061605426
Sum	585060
Variance	158.55356
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52	1265	6.2%
36	856	4.2%
35	818	4.0%
16	762	3.7%
17	694	3.4%
34	682	3.3%
26	611	3.0%
33	609	3.0%
25	562	2.8%
32	560	2.7%
Other values (42)	13014	63.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	< 0.1%
2	58	0.3%
3	62	0.3%
4	190	0.9%
5	242	1.2%
6	157	0.8%
7	173	0.8%
8	203	1.0%
9	204	1.0%
10	263	1.3%

Value	Count	Frequency (%)
52	1265	6.2%
51	47	0.2%
50	135	0.7%
49	133	0.7%
48	174	0.9%
47	195	1.0%
46	245	1.2%
45	286	1.4%
44	353	1.7%
43	351	1.7%

total_rooms
Real number (ℝ)

Distinct	5911
Distinct (%)	28.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2636.5042

Minimum	2
Maximum	39320
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	319.3 KiB

Quantile statistics

Minimum	2
5-th percentile	622
Q1	1450
median	2127
Q3	3143
95-th percentile	6217
Maximum	39320
Range	39318
Interquartile range (IQR)	1693

Descriptive statistics

Standard deviation	2185.2696
Coefficient of variation (CV)	0.82885115
Kurtosis	32.713859
Mean	2636.5042
Median Absolute Deviation (MAD)	795
Skewness	4.1588164
Sum	53871691
Variance	4775403.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1527	18	0.1%
1582	17	0.1%
1613	17	0.1%
2127	16	0.1%
2053	15	0.1%
1722	15	0.1%
1703	15	0.1%
1471	15	0.1%
1717	15	0.1%
1607	15	0.1%
Other values (5901)	20275	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%
15	2	< 0.1%
16	1	< 0.1%
18	4	< 0.1%
19	2	< 0.1%
20	2	< 0.1%

Value	Count	Frequency (%)
39320	1	< 0.1%
37937	1	< 0.1%
32627	1	< 0.1%
32054	1	< 0.1%
30450	1	< 0.1%
30405	1	< 0.1%
30401	1	< 0.1%
28258	1	< 0.1%
27870	1	< 0.1%
27700	1	< 0.1%

total_bedrooms
Real number (ℝ)

Distinct	1923
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	537.87055

Minimum	1
Maximum	6445
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	319.3 KiB

Quantile statistics

Minimum	1
5-th percentile	137
Q1	296
median	435
Q3	647
95-th percentile	1275.4
Maximum	6445
Range	6444
Interquartile range (IQR)	351

Descriptive statistics

Standard deviation	421.38507
Coefficient of variation (CV)	0.78343213
Kurtosis	21.985575
Mean	537.87055
Median Absolute Deviation (MAD)	162
Skewness	3.4595463
Sum	10990309
Variance	177565.38
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
280	55	0.3%
331	51	0.2%
345	50	0.2%
343	49	0.2%
393	49	0.2%
328	48	0.2%
394	48	0.2%
348	48	0.2%
272	47	0.2%
309	47	0.2%
Other values (1913)	19941	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	< 0.1%
3	5	< 0.1%
4	7	< 0.1%
5	6	< 0.1%
6	5	< 0.1%
7	6	< 0.1%
8	8	< 0.1%
9	7	< 0.1%
10	8	< 0.1%

Value	Count	Frequency (%)
6445	1	< 0.1%
6210	1	< 0.1%
5471	1	< 0.1%
5419	1	< 0.1%
5290	1	< 0.1%
5033	1	< 0.1%
5027	1	< 0.1%
4957	1	< 0.1%
4952	1	< 0.1%
4819	1	< 0.1%

population
Real number (ℝ)

Distinct	3879
Distinct (%)	19.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1424.9469

Minimum	3
Maximum	35682
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	319.3 KiB

Quantile statistics

Minimum	3
5-th percentile	348
Q1	787
median	1166
Q3	1722
95-th percentile	3284.4
Maximum	35682
Range	35679
Interquartile range (IQR)	935

Descriptive statistics

Standard deviation	1133.2085
Coefficient of variation (CV)	0.79526363
Kurtosis	74.060888
Mean	1424.9469
Median Absolute Deviation (MAD)	439
Skewness	4.9600165
Sum	29115941
Variance	1284161.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
891	25	0.1%
850	24	0.1%
761	24	0.1%
1052	24	0.1%
1227	24	0.1%
782	22	0.1%
1005	22	0.1%
825	22	0.1%
872	21	0.1%
753	21	0.1%
Other values (3869)	20204	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
8	4	< 0.1%
9	2	< 0.1%
11	1	< 0.1%
13	4	< 0.1%
14	3	< 0.1%
15	2	< 0.1%
17	2	< 0.1%

Value	Count	Frequency (%)
35682	1	< 0.1%
28566	1	< 0.1%
16305	1	< 0.1%
16122	1	< 0.1%
15507	1	< 0.1%
15037	1	< 0.1%
13251	1	< 0.1%
12873	1	< 0.1%
12427	1	< 0.1%
12203	1	< 0.1%

households
Real number (ℝ)

Distinct	1809
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	499.43347

Minimum	1
Maximum	6082
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	319.3 KiB

Quantile statistics

Minimum	1
5-th percentile	125
Q1	280
median	409
Q3	604
95-th percentile	1159
Maximum	6082
Range	6081
Interquartile range (IQR)	324

Descriptive statistics

Standard deviation	382.29923
Coefficient of variation (CV)	0.76546578
Kurtosis	22.094083
Mean	499.43347
Median Absolute Deviation (MAD)	151
Skewness	3.4138502
Sum	10204924
Variance	146152.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
306	57	0.3%
335	56	0.3%
282	55	0.3%
386	55	0.3%
429	54	0.3%
297	51	0.2%
375	51	0.2%
284	51	0.2%
278	50	0.2%
362	50	0.2%
Other values (1799)	19903	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	3	< 0.1%
3	4	< 0.1%
4	4	< 0.1%
5	7	< 0.1%
6	5	< 0.1%
7	10	< 0.1%
8	8	< 0.1%
9	9	< 0.1%
10	7	< 0.1%

Value	Count	Frequency (%)
6082	1	< 0.1%
5358	1	< 0.1%
5189	1	< 0.1%
5050	1	< 0.1%
4930	1	< 0.1%
4855	1	< 0.1%
4769	1	< 0.1%
4616	1	< 0.1%
4490	1	< 0.1%
4372	1	< 0.1%

median_income
Real number (ℝ)

Distinct	12825
Distinct (%)	62.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.8711616

Minimum	0.4999
Maximum	15.0001
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	319.3 KiB

Quantile statistics

Minimum	0.4999
5-th percentile	1.60066
Q1	2.5637
median	3.5365
Q3	4.744
95-th percentile	7.30034
Maximum	15.0001
Range	14.5002
Interquartile range (IQR)	2.1803

Descriptive statistics

Standard deviation	1.8992912
Coefficient of variation (CV)	0.49062567
Kurtosis	4.9431411
Mean	3.8711616
Median Absolute Deviation (MAD)	1.0649
Skewness	1.6445569
Sum	79099.445
Variance	3.6073072
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.125	49	0.2%
15.0001	48	0.2%
2.875	46	0.2%
4.125	44	0.2%
2.625	44	0.2%
3.875	41	0.2%
3.375	38	0.2%
4	37	0.2%
3	37	0.2%
3.625	36	0.2%
Other values (12815)	20013	97.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.4999	12	0.1%
0.536	10	< 0.1%
0.5495	1	< 0.1%
0.6433	1	< 0.1%
0.6775	1	< 0.1%
0.6825	1	< 0.1%
0.6831	1	< 0.1%
0.696	1	< 0.1%
0.6991	1	< 0.1%
0.7007	1	< 0.1%

Value	Count	Frequency (%)
15.0001	48	0.2%
15	2	< 0.1%
14.9009	1	< 0.1%
14.5833	1	< 0.1%
14.4219	1	< 0.1%
14.4113	1	< 0.1%
14.2959	1	< 0.1%
14.2867	1	< 0.1%
13.947	1	< 0.1%
13.8556	1	< 0.1%

median_house_value
Real number (ℝ)

Distinct	3833
Distinct (%)	18.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	206864.41

Minimum	14999
Maximum	500001
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	319.3 KiB

Quantile statistics

Minimum	14999
5-th percentile	66260
Q1	119500
median	179700
Q3	264700
95-th percentile	490560
Maximum	500001
Range	485002
Interquartile range (IQR)	145200

Descriptive statistics

Standard deviation	115435.67
Coefficient of variation (CV)	0.55802574
Kurtosis	0.32803747
Mean	206864.41
Median Absolute Deviation (MAD)	68400
Skewness	0.97828989
Sum	4.2268606 × 10⁹
Variance	1.3325393 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
500001	958	4.7%
137500	119	0.6%
162500	116	0.6%
112500	103	0.5%
187500	92	0.5%
225000	91	0.4%
350000	79	0.4%
87500	77	0.4%
275000	65	0.3%
150000	64	0.3%
Other values (3823)	18669	91.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14999	4	< 0.1%
17500	1	< 0.1%
22500	4	< 0.1%
25000	1	< 0.1%
26600	1	< 0.1%
26900	1	< 0.1%
27500	1	< 0.1%
28300	1	< 0.1%
30000	2	< 0.1%
32500	4	< 0.1%

Value	Count	Frequency (%)
500001	958	4.7%
500000	27	0.1%
499100	1	< 0.1%
499000	1	< 0.1%
498800	1	< 0.1%
498700	1	< 0.1%
498600	1	< 0.1%
498400	1	< 0.1%
497600	1	< 0.1%
497400	1	< 0.1%

ocean_proximity
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	319.3 KiB

<1H OCEAN	9034
INLAND	6496
NEAR OCEAN	2628
NEAR BAY	2270
ISLAND	5

Length

Max length	10
Median length	9
Mean length	8.0630353
Min length	6

Characters and Unicode

Total characters	164752
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NEAR BAY
2nd row	NEAR BAY
3rd row	NEAR BAY
4th row	NEAR BAY
5th row	NEAR BAY

Common Values

Value	Count	Frequency (%)
<1H OCEAN	9034	44.2%
INLAND	6496	31.8%
NEAR OCEAN	2628	12.9%
NEAR BAY	2270	11.1%
ISLAND	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ocean	11662	33.9%
1h	9034	26.3%
inland	6496	18.9%
near	4898	14.3%
bay	2270	6.6%
island	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	29557	17.9%
A	25331	15.4%
E	16560	10.1%
	13932	8.5%
O	11662	7.1%
C	11662	7.1%
<	9034	5.5%
1	9034	5.5%
H	9034	5.5%
I	6501	3.9%
Other values (6)	22445	13.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	164752	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	29557	17.9%
A	25331	15.4%
E	16560	10.1%
	13932	8.5%
O	11662	7.1%
C	11662	7.1%
<	9034	5.5%
1	9034	5.5%
H	9034	5.5%
I	6501	3.9%
Other values (6)	22445	13.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	164752	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	29557	17.9%
A	25331	15.4%
E	16560	10.1%
	13932	8.5%
O	11662	7.1%
C	11662	7.1%
<	9034	5.5%
1	9034	5.5%
H	9034	5.5%
I	6501	3.9%
Other values (6)	22445	13.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	164752	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	29557	17.9%
A	25331	15.4%
E	16560	10.1%
	13932	8.5%
O	11662	7.1%
C	11662	7.1%
<	9034	5.5%
1	9034	5.5%
H	9034	5.5%
I	6501	3.9%
Other values (6)	22445	13.6%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	longitude	latitude	housing_median_age	total_rooms	total_bedrooms	population	households	median_income	median_house_value	ocean_proximity
0	-122.23	37.88	41.0	880.0	129.0	322.0	126.0	8.3252	452600.0	NEAR BAY
1	-122.22	37.86	21.0	7099.0	1106.0	2401.0	1138.0	8.3014	358500.0	NEAR BAY
2	-122.24	37.85	52.0	1467.0	190.0	496.0	177.0	7.2574	352100.0	NEAR BAY
3	-122.25	37.85	52.0	1274.0	235.0	558.0	219.0	5.6431	341300.0	NEAR BAY
4	-122.25	37.85	52.0	1627.0	280.0	565.0	259.0	3.8462	342200.0	NEAR BAY
5	-122.25	37.85	52.0	919.0	213.0	413.0	193.0	4.0368	269700.0	NEAR BAY
6	-122.25	37.84	52.0	2535.0	489.0	1094.0	514.0	3.6591	299200.0	NEAR BAY
7	-122.25	37.84	52.0	3104.0	687.0	1157.0	647.0	3.1200	241400.0	NEAR BAY
8	-122.26	37.84	42.0	2555.0	665.0	1206.0	595.0	2.0804	226700.0	NEAR BAY
9	-122.25	37.84	52.0	3549.0	707.0	1551.0	714.0	3.6912	261100.0	NEAR BAY

	longitude	latitude	housing_median_age	total_rooms	total_bedrooms	population	households	median_income	median_house_value	ocean_proximity
20630	-121.32	39.29	11.0	2640.0	505.0	1257.0	445.0	3.5673	112000.0	INLAND
20631	-121.40	39.33	15.0	2655.0	493.0	1200.0	432.0	3.5179	107200.0	INLAND
20632	-121.45	39.26	15.0	2319.0	416.0	1047.0	385.0	3.1250	115600.0	INLAND
20633	-121.53	39.19	27.0	2080.0	412.0	1082.0	382.0	2.5495	98300.0	INLAND
20634	-121.56	39.27	28.0	2332.0	395.0	1041.0	344.0	3.7125	116800.0	INLAND
20635	-121.09	39.48	25.0	1665.0	374.0	845.0	330.0	1.5603	78100.0	INLAND
20636	-121.21	39.49	18.0	697.0	150.0	356.0	114.0	2.5568	77100.0	INLAND
20637	-121.22	39.43	17.0	2254.0	485.0	1007.0	433.0	1.7000	92300.0	INLAND
20638	-121.32	39.43	18.0	1860.0	409.0	741.0	349.0	1.8672	84700.0	INLAND
20639	-121.24	39.37	16.0	2785.0	616.0	1387.0	530.0	2.3886	89400.0	INLAND

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Missing values

Sample